﻿
If Exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_FullAndDiscount') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_FullAndDiscount
END
GO
	CREATE VIEW V_FullAndDiscount
	AS 
	SELECT [SalesPromotionInfoGuid]
      ,[MinimalCost]
      ,[DiscountMode]
      ,[Number]
  FROM [ShopNum1_FullAndDiscount]
	
